<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
<title>i2c: C:/Users/Jon/Downloads/OOP/db-control/dbInstall.php Source File</title>

<link href="tabs.css" rel="stylesheet" type="text/css"/>
<link href="doxygen.css" rel="stylesheet" type="text/css" />

<link href="search/search.css" rel="stylesheet" type="text/css"/>
<script type="text/javascript" src="jquery.js"></script>
<script type="text/javascript" src="search/search.js"></script>
<script type="text/javascript">
  $(document).ready(function() { searchBox.OnSelectItem(0); });
</script>

</head>
<body>
<div id="top"><!-- do not remove this div! -->


<div id="titlearea">
<table cellspacing="0" cellpadding="0">
 <tbody>
 <tr style="height: 56px;">
  
  
  <td style="padding-left: 0.5em;">
   <div id="projectname">i2c
   
   </div>
   
  </td>
  
  
  
 </tr>
 </tbody>
</table>
</div>

<!-- Generated by Doxygen 1.7.5.1 -->
<script type="text/javascript">
var searchBox = new SearchBox("searchBox", "search",false,'Search');
</script>
  <div id="navrow1" class="tabs">
    <ul class="tablist">
      <li><a href="index.html"><span>Main&#160;Page</span></a></li>
      <li><a href="pages.html"><span>Related&#160;Pages</span></a></li>
      <li><a href="annotated.html"><span>Data&#160;Structures</span></a></li>
      <li class="current"><a href="files.html"><span>Files</span></a></li>
      <li>
        <div id="MSearchBox" class="MSearchBoxInactive">
        <span class="left">
          <img id="MSearchSelect" src="search/mag_sel.png"
               onmouseover="return searchBox.OnSearchSelectShow()"
               onmouseout="return searchBox.OnSearchSelectHide()"
               alt=""/>
          <input type="text" id="MSearchField" value="Search" accesskey="S"
               onfocus="searchBox.OnSearchFieldFocus(true)" 
               onblur="searchBox.OnSearchFieldFocus(false)" 
               onkeyup="searchBox.OnSearchFieldChange(event)"/>
          </span><span class="right">
            <a id="MSearchClose" href="javascript:searchBox.CloseResultsWindow()"><img id="MSearchCloseImg" border="0" src="search/close.png" alt=""/></a>
          </span>
        </div>
      </li>
    </ul>
  </div>
  <div id="navrow2" class="tabs2">
    <ul class="tablist">
      <li><a href="files.html"><span>File&#160;List</span></a></li>
      <li><a href="globals.html"><span>Globals</span></a></li>
    </ul>
  </div>
<div class="header">
  <div class="headertitle">
<div class="title">C:/Users/Jon/Downloads/OOP/db-control/dbInstall.php</div>  </div>
</div>
<div class="contents">
<a href="db_install_8php.html">Go to the documentation of this file.</a><div class="fragment"><pre class="fragment"><a name="l00001"></a>00001 &lt;?php
<a name="l00002"></a>00002 <span class="comment">/*</span>
<a name="l00003"></a>00003 <span class="comment"> * Copyright 2008 by Aaron Jarzombek, Brice Rader, Dan Pepin, Michael Tierny</span>
<a name="l00004"></a>00004 <span class="comment"> * and Steve Simard.  This program is part of the University of New Hampshire</span>
<a name="l00005"></a>00005 <span class="comment"> * at Manchester Internship Program.</span>
<a name="l00006"></a>00006 <span class="comment"> * General Public License as published by the Free Software Foundation</span>
<a name="l00007"></a>00007 <span class="comment"> * (see &lt;http://www.gnu.org/licenses/ for more information).</span>
<a name="l00008"></a>00008 <span class="comment"> */</span>
<a name="l00009"></a>00009 
<a name="l00017"></a>00017 ?&gt;
<a name="l00018"></a>00018 
<a name="l00019"></a>00019 &lt;html&gt;
<a name="l00020"></a>00020     &lt;title&gt;
<a name="l00021"></a>00021         Database Initialization
<a name="l00022"></a>00022     &lt;/title&gt;
<a name="l00023"></a>00023     &lt;body&gt;
<a name="l00024"></a>00024         &lt;?php
<a name="l00025"></a>00025         echo (<span class="stringliteral">&quot;Attempting to install tables...&lt;br /&gt;&quot;</span>);
<a name="l00026"></a>00026         include(<span class="stringliteral">&#39;inc/dbInfo.php&#39;</span>);
<a name="l00027"></a>00027         include(<span class="stringliteral">&#39;inc/functions.php&#39;</span>);
<a name="l00028"></a>00028         include(<span class="stringliteral">&#39;dbOrganization.php&#39;</span>);
<a name="l00029"></a>00029         include(<span class="stringliteral">&#39;dbCategory.php&#39;</span>);
<a name="l00030"></a>00030         include(<span class="stringliteral">&#39;dbContact.php&#39;</span>);
<a name="l00031"></a>00031         include(<span class="stringliteral">&#39;dbStudent.php&#39;</span>);
<a name="l00032"></a>00032         include(<span class="stringliteral">&#39;dbOpportunity.php&#39;</span>);
<a name="l00033"></a>00033         include(<span class="stringliteral">&#39;dbMajor.php&#39;</span>);
<a name="l00034"></a>00034         include(<span class="stringliteral">&#39;dbInternship.php&#39;</span>);
<a name="l00035"></a>00035         include(<span class="stringliteral">&#39;dbUser.php&#39;</span>);
<a name="l00036"></a>00036 
<a name="l00037"></a><a class="code" href="db_install_8php.html#a0a71190f67ae9de9e6f5ababdad0e938">00037</a>         <a class="code" href="db_install_8php.html#a0a71190f67ae9de9e6f5ababdad0e938">$db_server</a> = mysql_connect(<a class="code" href="db-control_2inc_2db_info_8php.html#a711797613cb863ca0756df789c396bf2">$host</a>, <a class="code" href="db-control_2inc_2db_info_8php.html#a0eb82aa5f81cf845de4b36cd653c42cf">$username</a>, <a class="code" href="db-control_2inc_2db_info_8php.html#a607686ef9f99ea7c42f4f3dd3dbb2b0d">$password</a>);
<a name="l00038"></a>00038         <span class="keywordflow">if</span> (!<a class="code" href="db_install_8php.html#a0a71190f67ae9de9e6f5ababdad0e938">$db_server</a>
<a name="l00039"></a>00039 
<a name="l00040"></a>00040             )die(<span class="stringliteral">&quot;Cannot connect to the MySQL database!&lt;br /&gt;Please</span>
<a name="l00041"></a>00041 <span class="stringliteral">            contact your database administrator.&quot;</span>);
<a name="l00042"></a>00042 
<a name="l00043"></a>00043         mysql_query(<span class="stringliteral">&quot;DROP DATABASE IF EXISTS i2c&quot;</span>);
<a name="l00044"></a>00044         mysql_query(<span class="stringliteral">&quot;CREATE DATABASE i2c&quot;</span>);
<a name="l00045"></a>00045                 
<a name="l00046"></a><a class="code" href="db_install_8php.html#a76fb93cce64a9b34c9fd360ec121c15d">00046</a>                  <a class="code" href="db_install_8php.html#a76fb93cce64a9b34c9fd360ec121c15d">$db_selected</a> = mysql_select_db(<a class="code" href="db-control_2inc_2db_info_8php.html#a7691c0162d89de0b6ba47edcd8ba8878">$database</a>, <a class="code" href="db_install_8php.html#a0a71190f67ae9de9e6f5ababdad0e938">$db_server</a>);
<a name="l00047"></a><a class="code" href="db_install_8php.html#ad7e172c4e8458f5ac8d3753fbd8eedf8">00047</a>         <span class="keywordflow">if</span> (!<a class="code" href="db_install_8php.html#a76fb93cce64a9b34c9fd360ec121c15d">$db_selected</a>) {
<a name="l00048"></a>00048             die(<span class="stringliteral">&quot;Cannot select database $database.&quot;</span> . mysql_error());
<a name="l00049"></a>00049         };
<a name="l00050"></a>00050 
<a name="l00051"></a>00051         mysql_select_db(<a class="code" href="db-control_2inc_2db_info_8php.html#a7691c0162d89de0b6ba47edcd8ba8878">$database</a>) or die(&quot;Cannot select the database!&lt;br /&gt;
<a name="l00052"></a>00052             Please make sure it has been installed properly!&quot;);
<a name="l00053"></a>00053 
<a name="l00054"></a>00054                 mysql_query(&quot;DROP USER &#39;i2c&#39;@&#39;%&#39;&quot;);
<a name="l00055"></a>00055                 mysql_query(&quot;DROP USER &#39;i2c&#39;@&#39;localhost&#39;&quot;);
<a name="l00056"></a>00056                 mysql_query(&quot;CREATE USER &#39;i2c&#39;@&#39;%&#39; IDENTIFIED BY &#39;i2c&#39;&quot;);
<a name="l00057"></a>00057                 mysql_query(&quot;CREATE USER &#39;i2c&#39;@&#39;localhost&#39; IDENTIFIED BY &#39;i2c&#39;&quot;);
<a name="l00058"></a>00058                 mysql_query(&quot;GRANT ALL privileges ON i2c.* TO &#39;i2c&#39;@&#39;%&#39; IDENTIFIED BY &#39;i2c&#39; with grant option&quot;);
<a name="l00059"></a>00059                 mysql_query(&quot;GRANT ALL privileges ON i2c.* TO &#39;i2c&#39;@&#39;localhost&#39; IDENTIFIED BY &#39;i2c&#39; with
<a name="l00060"></a>00060 grant option&quot;);
<a name="l00061"></a>00061         
<a name="l00062"></a>00062 
<a name="l00063"></a>00063 
<a name="l00064"></a>00064                         
<a name="l00065"></a>00065         <span class="comment">//ORGANIZATION</span>
<a name="l00066"></a><a class="code" href="db_install_8php.html#a112ef069ddc0454086e3d1e6d8d55d07">00066</a>         <a class="code" href="admin_2internship__list_8php.html#a112ef069ddc0454086e3d1e6d8d55d07">$result</a> = <a class="code" href="classdb_organization.html">dbOrganization</a>::createTable();
<a name="l00067"></a>00067         <a class="code" href="db_install_8php.html#ad7e172c4e8458f5ac8d3753fbd8eedf8">if</a> (!<a class="code" href="admin_2internship__list_8php.html#a112ef069ddc0454086e3d1e6d8d55d07">$result</a>
<a name="l00068"></a>00068 
<a name="l00069"></a>00069             )die(&quot;Could not create table &#39;organization&#39;: &quot; . mysql_error());
<a name="l00070"></a>00070         echo (&quot;Added table &#39;organization&#39; successfully...&lt;br /&gt;&quot;);
<a name="l00071"></a>00071 
<a name="l00072"></a>00072         <span class="comment">//CATEGORY</span>
<a name="l00073"></a>00073         <a class="code" href="admin_2internship__list_8php.html#a112ef069ddc0454086e3d1e6d8d55d07">$result</a> = <a class="code" href="classdb_category.html">dbCategory</a>::createTable();
<a name="l00074"></a>00074         <a class="code" href="db_install_8php.html#ad7e172c4e8458f5ac8d3753fbd8eedf8">if</a> (!<a class="code" href="admin_2internship__list_8php.html#a112ef069ddc0454086e3d1e6d8d55d07">$result</a>
<a name="l00075"></a>00075 
<a name="l00076"></a>00076             )die(&quot;Could not create table &#39;category&#39;: &quot; . mysql_error());
<a name="l00077"></a>00077         echo (&quot;Added table &#39;category&#39; successfully...&lt;br /&gt;&quot;);
<a name="l00078"></a>00078 
<a name="l00079"></a>00079         <span class="comment">//CONTACT</span>
<a name="l00080"></a>00080         <a class="code" href="admin_2internship__list_8php.html#a112ef069ddc0454086e3d1e6d8d55d07">$result</a> = <a class="code" href="classdb_contact.html">dbContact</a>::createTable();
<a name="l00081"></a>00081         <a class="code" href="db_install_8php.html#ad7e172c4e8458f5ac8d3753fbd8eedf8">if</a> (!<a class="code" href="admin_2internship__list_8php.html#a112ef069ddc0454086e3d1e6d8d55d07">$result</a>
<a name="l00082"></a>00082 
<a name="l00083"></a>00083             )die(&quot;Could not create table &#39;contact&#39;: &quot; . mysql_error());
<a name="l00084"></a>00084         echo (&quot;Added table &#39;contact&#39; successfully...&lt;br /&gt;&quot;);
<a name="l00085"></a>00085 
<a name="l00086"></a>00086         <span class="comment">//STUDENT</span>
<a name="l00087"></a>00087         <a class="code" href="admin_2internship__list_8php.html#a112ef069ddc0454086e3d1e6d8d55d07">$result</a> = <a class="code" href="classdb_student.html">dbStudent</a>::createTable();
<a name="l00088"></a>00088         <a class="code" href="db_install_8php.html#ad7e172c4e8458f5ac8d3753fbd8eedf8">if</a> (!<a class="code" href="admin_2internship__list_8php.html#a112ef069ddc0454086e3d1e6d8d55d07">$result</a>
<a name="l00089"></a>00089 
<a name="l00090"></a>00090             )die(&quot;Could not create table &#39;student&#39;: &quot; . mysql_error());
<a name="l00091"></a>00091         echo (&quot;Added table &#39;student&#39; successfully...&lt;br /&gt;&quot;);
<a name="l00092"></a>00092 
<a name="l00093"></a>00093         <span class="comment">//OPPORTUNITY</span>
<a name="l00094"></a>00094         <a class="code" href="admin_2internship__list_8php.html#a112ef069ddc0454086e3d1e6d8d55d07">$result</a> = <a class="code" href="classdb_opportunity.html">dbOpportunity</a>::createTable();
<a name="l00095"></a>00095         <a class="code" href="db_install_8php.html#ad7e172c4e8458f5ac8d3753fbd8eedf8">if</a> (!<a class="code" href="admin_2internship__list_8php.html#a112ef069ddc0454086e3d1e6d8d55d07">$result</a>
<a name="l00096"></a>00096 
<a name="l00097"></a>00097             )die(&quot;Could not create table &#39;opportunity&#39;: &quot; . mysql_error());
<a name="l00098"></a>00098         echo (&quot;Added table &#39;opportunity&#39; successfully...&lt;br /&gt;&quot;);
<a name="l00099"></a>00099 
<a name="l00100"></a>00100         <span class="comment">//MAJOR</span>
<a name="l00101"></a>00101         <a class="code" href="admin_2internship__list_8php.html#a112ef069ddc0454086e3d1e6d8d55d07">$result</a> = <a class="code" href="classdb_major.html">dbMajor</a>::createTable();
<a name="l00102"></a>00102         <a class="code" href="db_install_8php.html#ad7e172c4e8458f5ac8d3753fbd8eedf8">if</a> (!<a class="code" href="admin_2internship__list_8php.html#a112ef069ddc0454086e3d1e6d8d55d07">$result</a>
<a name="l00103"></a>00103 
<a name="l00104"></a>00104             )die(&quot;Could not create table &#39;major&#39;: &quot; . mysql_error());
<a name="l00105"></a>00105         echo (&quot;Added table &#39;major&#39; successfully...&lt;br /&gt;&quot;);
<a name="l00106"></a>00106 
<a name="l00107"></a>00107         <span class="comment">//INTERNSHIP</span>
<a name="l00108"></a>00108         <a class="code" href="admin_2internship__list_8php.html#a112ef069ddc0454086e3d1e6d8d55d07">$result</a> = <a class="code" href="classdb_internship.html">dbInternship</a>::createTable();
<a name="l00109"></a>00109         <a class="code" href="db_install_8php.html#ad7e172c4e8458f5ac8d3753fbd8eedf8">if</a> (!<a class="code" href="admin_2internship__list_8php.html#a112ef069ddc0454086e3d1e6d8d55d07">$result</a>
<a name="l00110"></a>00110 
<a name="l00111"></a>00111             )die(&quot;Could not create table &#39;internship&#39;: &quot; . mysql_error());
<a name="l00112"></a>00112         echo (&quot;Added table &#39;contact&#39; successfully...&lt;br /&gt;&quot;);
<a name="l00113"></a>00113 
<a name="l00114"></a>00114 
<a name="l00115"></a>00115         <span class="comment">//SYSUSER</span>
<a name="l00116"></a>00116         <a class="code" href="admin_2internship__list_8php.html#a112ef069ddc0454086e3d1e6d8d55d07">$result</a> = <a class="code" href="classdb_user.html">dbUser</a>::createTable();
<a name="l00117"></a>00117         <a class="code" href="db_install_8php.html#ad7e172c4e8458f5ac8d3753fbd8eedf8">if</a> (!<a class="code" href="admin_2internship__list_8php.html#a112ef069ddc0454086e3d1e6d8d55d07">$result</a>
<a name="l00118"></a>00118 
<a name="l00119"></a>00119             )die(&quot;Could not create table &#39;sysuser&#39;: &quot; . mysql_error());
<a name="l00120"></a>00120         echo (&quot;Added table &#39;sysuser&#39; successfully...&lt;br /&gt;&quot;);
<a name="l00121"></a>00121         echo(&quot;Installation of mysql tables complete.&quot;);
<a name="l00122"></a>00122         ?&gt;
<a name="l00123"></a>00123     &lt;/body&gt;
<a name="l00124"></a>00124 &lt;/html&gt;
</pre></div></div>
</div>
<!-- window showing the filter options -->
<div id="MSearchSelectWindow"
     onmouseover="return searchBox.OnSearchSelectShow()"
     onmouseout="return searchBox.OnSearchSelectHide()"
     onkeydown="return searchBox.OnSearchSelectKey(event)">
<a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(0)"><span class="SelectionMark">&#160;</span>All</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(1)"><span class="SelectionMark">&#160;</span>Data Structures</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(2)"><span class="SelectionMark">&#160;</span>Files</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(3)"><span class="SelectionMark">&#160;</span>Functions</a><a class="SelectItem" href="javascript:void(0)" onclick="searchBox.OnSelectItem(4)"><span class="SelectionMark">&#160;</span>Variables</a></div>

<!-- iframe showing the search results (closed by default) -->
<div id="MSearchResultsWindow">
<iframe src="javascript:void(0)" frameborder="0" 
        name="MSearchResults" id="MSearchResults">
</iframe>
</div>



<hr class="footer"/><address class="footer"><small>
Generated on Tue Nov 29 2011 18:18:54 for i2c by &#160;<a href="http://www.doxygen.org/index.html">
<img class="footer" src="doxygen.png" alt="doxygen"/>
</a> 1.7.5.1
</small></address>

</body>
</html>
